/*
Navicat MySQL Data Transfer

Source Server         : volunteer
Source Server Version : 50506
Source Host           : localhost:3306
Source Database       : volunteer

Target Server Type    : MYSQL
Target Server Version : 50506
File Encoding         : 65001

Date: 2023-05-17 21:19:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `activityinfo`
-- ----------------------------
DROP TABLE IF EXISTS `activityinfo`;
CREATE TABLE `activityinfo` (
`activityId`  int(11) NOT NULL AUTO_INCREMENT ,
`activityTitle`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`typeId`  int(11) NULL DEFAULT NULL ,
`activityContent`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`activityAdress`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`activityTime`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`activityPic`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`is_delete`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '0表示数据没有删除，1表示数据已经删除了' ,
`exa_state`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '0是没有审批过' ,
PRIMARY KEY (`activityId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=15

;

-- ----------------------------
-- Records of activityinfo
-- ----------------------------
BEGIN;
INSERT INTO `activityinfo` VALUES ('1', '湖畔感恩', '2', '在我们前进的路上，总有些磕磕绊绊，也总有那些你认为的“过不去的坎儿”，但我们依然走在前进的路上。善良、乐于助人、善解人意，是这样一群人帮助你穿过层层阻碍。', '理科群楼', '2023/1/30', 'https://pic2.imgdb.cn/item/6460edfe0d2dde577761b29d.jpg', '0', '1'), ('2', '迎春送暖', '3', '前往红太阳敬老院看望老人，与老人交流谈心，给老人展示才艺', '校外', '2023/3/4', 'https://pic2.imgdb.cn/item/6460ef120d2dde577763d019.png', '0', '1'), ('3', '捐资易书', '2', '同学们可以凭借自己的物品换取资料', '西操场', '2023/4/5', 'https://pic2.imgdb.cn/item/6460eef10d2dde5777638a95.jpg', '0', '1'), ('4', '情暖归途', '2', '志愿者前往石家庄站，帮助旅客解决问题', '石家庄站', '2023/4/6', 'https://pic2.imgdb.cn/item/6460ef350d2dde57776421b8.jpg', '0', '1'), ('14', '测试', '2', '测试', '测试', '2023/2/2', 'https://pic2.imgdb.cn/item/6460ef350d2dde57776421b8.jpg', '0', '1');
COMMIT;

-- ----------------------------
-- Table structure for `comments`
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`commentsId`  int(11) NOT NULL AUTO_INCREMENT ,
`userName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`user_pic`  varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
`contents`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`commentsId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=17

;

-- ----------------------------
-- Records of comments
-- ----------------------------
BEGIN;
INSERT INTO `comments` VALUES ('1', '甲', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '志愿者在行动！'), ('2', '刘艳芬', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '捡垃圾咯'), ('3', '懂', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '经过小志愿者的努力，垃圾越来越少'), ('4', '', null, 'qecwrv'), ('5', '', null, '这是提交的内容'), ('6', '', null, '这是提交的内容'), ('7', '', null, '这是提交的内容'), ('8', '', null, '这是提交的内容'), ('9', null, null, 'f'), ('10', null, null, 'fe'), ('11', null, null, 'fef'), ('12', null, null, 'd'), ('13', null, null, 'dd'), ('14', null, null, 'ddd'), ('15', null, null, '这是提交的内容'), ('16', null, null, '这是提交的内容');
COMMIT;

-- ----------------------------
-- Table structure for `newsinfo`
-- ----------------------------
DROP TABLE IF EXISTS `newsinfo`;
CREATE TABLE `newsinfo` (
`newsId`  int(11) NOT NULL AUTO_INCREMENT ,
`newsTitle`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`newsContent`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pub_date`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`cover_img`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_delete`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '0表示数据没有被删除，1表示数据被删除了' ,
`typeId`  int(11) NOT NULL ,
`authorId`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`newsId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=11

;

-- ----------------------------
-- Records of newsinfo
-- ----------------------------
BEGIN;
INSERT INTO `newsinfo` VALUES ('1', '111111qwdwedq2e', '11232qwdefwgrthryjukilo;p\'[', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '0', '0', null), ('2', '11111', '13e2r4t54y6', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '1', '0', null), ('3', '12345678', '', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '1', '0', null), ('4', '111111', '11232', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '1', '0', null), ('5', '111111qwdw', '11232qwdefwgrthryjukilo;p\'[', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '0', '0', null), ('6', '12343546', '2132453', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '1', '0', null), ('7', 'asfdsghkjl;', 'sadfghjk/.', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '0', '0', null), ('8', '新闻标题', 'sadfghjk/.', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '0', '0', null), ('9', '新闻标题ing', '新闻发布不不不不不不不不不不', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '0', '0', null), ('10', '我', '我', '', 'https://pic2.imgdb.cn/item/6460f3c60d2dde57776f84cd.jpg', '0', '0', null);
COMMIT;

-- ----------------------------
-- Table structure for `teacherinfo`
-- ----------------------------
DROP TABLE IF EXISTS `teacherinfo`;
CREATE TABLE `teacherinfo` (
`userId`  int(11) NOT NULL AUTO_INCREMENT COMMENT '教师ID' ,
`userName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '教师名字' ,
`password`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '志愿者密码' ,
`teacherMotto`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '志愿者座右铭' ,
`nickName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教师昵称' ,
`teacher_pic`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教师头像' ,
`email`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '教师邮箱' ,
`is_delete`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '0表示没有删除' ,
PRIMARY KEY (`userId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=10

;

-- ----------------------------
-- Records of teacherinfo
-- ----------------------------
BEGIN;
INSERT INTO `teacherinfo` VALUES ('1', '111111', '$2a$10$S3rh.WJNj4P.uIvBUB7aTuKSV3az3np9hfQq92JJXNBDCMUFD.fXu', '2132r4t54y657', '教师1', 'https://pic2.imgdb.cn/item/6460f22f0d2dde57776b1d0b.jpg', 'qde@qq.com', '0'), ('2', 'aaaaaaa', 'aaaaaa', '2132r4t54y657', '开心', 'https://pic2.imgdb.cn/item/6460f2670d2dde57776b9a15.jpg', '1234@163.com', '0'), ('3', '3333333', '$2a$10$mQswJ44ZOLurk1tb/WGhK.QJqf.KCsg47cmSAGaF8y/6UOzeS9rDi', null, '快乐', 'https://pic2.imgdb.cn/item/6460f22f0d2dde57776b1d0b.jpg', null, '0'), ('4', '000000', '$2a$10$6ML/VOKQZHL1sm3JfScD6eJ6XpK7restdft8nZh1EmvJ3HiKiaLxy', null, '幸福', 'https://pic2.imgdb.cn/item/6460f2670d2dde57776b9a15.jpg', null, '0'), ('5', '888888', '$2a$10$u6UWVSC8jOexSzwp16gzqeriXwxzfEbt3WVZCLEUgDU087oSQsVKG', null, '安康', 'https://pic2.imgdb.cn/item/6460f2670d2dde57776b9a15.jpg', null, '0'), ('6', 'aaaaaa', '$2a$10$VTtuF2b7py4ccr2f9klqcOu1WRjQdpAIgMZJdVpnMIPmNHH4XUaAC', null, '美丽', 'https://pic2.imgdb.cn/item/6460f22f0d2dde57776b1d0b.jpg', null, '0'), ('7', '121asdc', '$2a$10$d1p5dkTIJSWSABScNuwVG.1dh/bF1CvezdWAtEg3969f6nBSxPnQ.', null, '优秀', 'https://pic2.imgdb.cn/item/6460f2670d2dde57776b9a15.jpg', '11111@qq.com', '0'), ('8', '121', '$2a$10$52vvVd8lByD3cYIUsdNmcuaOnbFLbUcaC11FiPXt6R4Ql7YqjBKDu', null, 'good', 'https://pic2.imgdb.cn/item/6460ebbe0d2dde57775de77a.jpg', 'qwerty@qq.con', '0'), ('9', '121qdedq', '$2a$10$uQPGzK8umk/JBxAqhZPP.e0zBtOYP4qMU/83Pp8bzw6wbNHmddEIi', null, 'brave', 'https://pic2.imgdb.cn/item/6460f22f0d2dde57776b1d0b.jpg', '11233@11.com', '0');
COMMIT;

-- ----------------------------
-- Table structure for `teaminfo`
-- ----------------------------
DROP TABLE IF EXISTS `teaminfo`;
CREATE TABLE `teaminfo` (
`teamId`  int(11) NOT NULL AUTO_INCREMENT ,
`teamName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`teamNum`  int(11) NOT NULL ,
`teamPic`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_delete`  tinyint(1) NULL DEFAULT 0 COMMENT '0表示没有删除' ,
`teamContent`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`teamId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of teaminfo
-- ----------------------------
BEGIN;
INSERT INTO `teaminfo` VALUES ('1', '学校志愿者协会', '80', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '0', '修改内容可以写依然可以不写'), ('2', '软件青年志愿者协会', '10', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '0', '这是志愿献血'), ('3', '学校消防协会', '80', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '0', '学校消防协会');
COMMIT;

-- ----------------------------
-- Table structure for `typeinfo`
-- ----------------------------
DROP TABLE IF EXISTS `typeinfo`;
CREATE TABLE `typeinfo` (
`typeId`  int(11) NOT NULL AUTO_INCREMENT ,
`typeName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`typeAlias`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_delete`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '0表示没有删除' ,
PRIMARY KEY (`typeId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=17

;

-- ----------------------------
-- Records of typeinfo
-- ----------------------------
BEGIN;
INSERT INTO `typeinfo` VALUES ('1', '清扫', 'QingSao', '1'), ('2', '关爱', 'GuanAi', '1'), ('3', '112f21d', 'e13e', '1'), ('4', '我喜欢jWED', 'ilikenwwwerfdgh', '1'), ('5', '我喜欢', 'ilike', '1'), ('6', '我喜欢你', 'ilikeni', '1'), ('7', '我喜欢你j', 'ilikenij', '1'), ('8', '我喜欢你YA', 'ilikenijA', '1'), ('9', '我喜', 'iliken', '1'), ('10', '我喜w', 'ilikenw', '1'), ('11', 'fwerbtqhen', 'fwqr', '0'), ('12', 'fwerbtqhenasd', 'fwqrdwq', '1'), ('13', 'q', 'q', '0'), ('14', '这是一个测试', '这是一个测试', '0'), ('15', '21', '12e', '1'), ('16', 'ftghj', 'ghj ', '0');
COMMIT;

-- ----------------------------
-- Table structure for `userinfo`
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`userId`  int(11) NOT NULL AUTO_INCREMENT ,
`userName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`password`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`nickName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`email`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`user_pic`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`userId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
BEGIN;
INSERT INTO `userinfo` VALUES ('1', 'mmmmmm', '$2a$10$ubOurJ6nof08VtY6oykQu.bYZ1Urf3Qwuhl7NkutKFJFF/RsD7CPG', '', '', ''), ('2', 'aaaaaaa', '$2a$10$Xln4nEuUPBahjEm9muk2kO4vfx25A4jadIlwDR7tigdoTFoWUq6PO', '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for `volunteerinfo`
-- ----------------------------
DROP TABLE IF EXISTS `volunteerinfo`;
CREATE TABLE `volunteerinfo` (
`userId`  int(11) NOT NULL AUTO_INCREMENT COMMENT '志愿者ID' ,
`userName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '志愿者名字' ,
`password`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '志愿者密码' ,
`volMotto`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '志愿者座右铭' ,
`volTime`  int(11) NULL DEFAULT NULL COMMENT '志愿时长' ,
`nickName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '志愿者昵称' ,
`vol_pic`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '志愿者头像' ,
`email`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '志愿者邮箱' ,
`is_delete`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '0表示没有删除' ,
`team_state`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '0为没有通过申请' ,
`teamId`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`userId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=16

;

-- ----------------------------
-- Records of volunteerinfo
-- ----------------------------
BEGIN;
INSERT INTO `volunteerinfo` VALUES ('11', 'yang', 'aaaaaa', '快乐 每一天', '77', '杨', 'https://pic2.imgdb.cn/item/6460f1a70d2dde577769bd65.png', '666666@qq.com', '0', '0', null), ('12', 'ma', 'aaaaaa', '加油', '22', '马', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '111111@qq.com', '0', '0', null), ('13', 'smart', '111111', '加油加油', '33', 'wao', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '1875081395@qq.com', '0', '0', null), ('14', '应', '888888', '应加油', '22', '应', 'https://pic2.imgdb.cn/item/6460f13e0d2dde577768b5e6.jpg', '888888@qq.com', '0', '0', null);
COMMIT;

-- ----------------------------
-- Auto increment value for `activityinfo`
-- ----------------------------
ALTER TABLE `activityinfo` AUTO_INCREMENT=15;

-- ----------------------------
-- Auto increment value for `comments`
-- ----------------------------
ALTER TABLE `comments` AUTO_INCREMENT=17;

-- ----------------------------
-- Auto increment value for `newsinfo`
-- ----------------------------
ALTER TABLE `newsinfo` AUTO_INCREMENT=11;

-- ----------------------------
-- Auto increment value for `teacherinfo`
-- ----------------------------
ALTER TABLE `teacherinfo` AUTO_INCREMENT=10;

-- ----------------------------
-- Auto increment value for `teaminfo`
-- ----------------------------
ALTER TABLE `teaminfo` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for `typeinfo`
-- ----------------------------
ALTER TABLE `typeinfo` AUTO_INCREMENT=17;

-- ----------------------------
-- Auto increment value for `userinfo`
-- ----------------------------
ALTER TABLE `userinfo` AUTO_INCREMENT=3;

-- ----------------------------
-- Auto increment value for `volunteerinfo`
-- ----------------------------
ALTER TABLE `volunteerinfo` AUTO_INCREMENT=16;
